<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" interactivePageBreakByFrame="true" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-11-15. 10:35:18--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; to &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; at 2014-7-25. 17:58:34--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; to &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; at 2014-7-25. 17:26:29--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; to &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; at 2014-7-25. 11:50:41-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Chargeback']/model[@name='model']</modelPath>
				<drillBehavior/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles><CSS value="background-color:white"/></style>
									<contents>
										
									<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#FBFBFB;color:#454545;padding-bottom:5px;border-bottom:1px solid #E2E2E1"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><style><defaultStyles><defaultStyle refStyle="tt"/></defaultStyles><CSS value="font-family:Helvetica;font-size:24px;text-decoration:none;color:#333333"/></style>
													<dataSource>
														<staticValue>NetApp Capacity by Aggregate</staticValue>
													</dataSource>
												</textItem></contents></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents><textItem><dataSource><staticValue>(Data as of </staticValue></dataSource></textItem><singleton name="Singleton1" refQuery="Latest Date">
			<contents><textItem><dataSource><dataItemValue refDataItem="latestdate"/></dataSource></textItem></contents>
		</singleton><textItem><dataSource><staticValue>)</staticValue></dataSource></textItem></contents><style><CSS value="vertical-align:bottom;text-align:right;color:#333333;font-family:Helvetica;font-size:12px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#FBFBFB;color:#454545;width:100%;height:36px;border-bottom:1px solid #E2E2E1"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:15px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><list horizontalPagination="true" name="List1" refQuery="Query1" rowsPerPage="1000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage System"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage System"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Aggregate"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Aggregate"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Date"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Raw Space"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/><dataFormat><numberFormat pattern="###,###,###,###,###.## GB"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Raw Space"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Space"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/><dataFormat><numberFormat pattern="###,###,###,###,###.## GB"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Space"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used Space"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/><dataFormat><numberFormat pattern="###,###,###,###,###.## GB"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Used Space"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used Space (%)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/><dataFormat><percentFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Used Space (%)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Available Space"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/><dataFormat><numberFormat pattern="###,###,###,###,###.## GB"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Available Space"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Committed Space"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/><dataFormat><numberFormat pattern="###,###,###,###,###.## GB"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Committed Space"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Commited Space (%)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/><dataFormat><percentFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Commited Space (%)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Change in Used Space"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Change in Used Space"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Change in Used Space (%)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Change in Used Space (%)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Change in Committed Space"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Change in Committed Space"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Change in Commited Space (%)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Change in Commited Space (%)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										<table>
											<tableRows>
												<tableRow>
													<tableCells>
														<tableCell>
															<contents>
																
															<image>
			<dataSource>
				<staticValue>../sanscreen/images/netapp_logo.png</staticValue>
			</dataSource>
		<style><CSS value="width:90px;height:36px"/></style></image></contents>
															<style>
																<CSS value="vertical-align:top;text-align:left;width:25%"/>
															</style>
														</tableCell>
														<tableCell>
															<contents>
																<textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
															</contents>
															<style>
																<CSS value="vertical-align:middle;text-align:center;width:50%;color:#9EA2A2;font-family:Helvetica;font-size:12px"/>
															</style>
														</tableCell>
														<tableCell>
															<contents>
																
															<textItem><dataSource><staticValue>OnCommand Insight</staticValue></dataSource></textItem></contents>
															<style>
																<CSS value="vertical-align:middle;text-align:right;width:25%;color:#9EA2A2;font-family:Helvetica;font-size:12px"/>
															</style>
														</tableCell>
													</tableCells>
												</tableRow>
											</tableRows>
											<style>
												<defaultStyles>
													<defaultStyle refStyle="tb"/>
												</defaultStyles>
												<CSS value="border-collapse:collapse;width:100%;height:32px"/>
											</style>
										</table>
									</contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding:12px 15px 13px 15px;background-image:url(../sanscreen/images/body-bg.png);background-position:left top;background-repeat:repeat;height:62px;border:1pt solid #E2E2E1"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2016-06-29T14:54:31.437Z"/></XMLAttributes><reportName>NetApp Capacity by Aggregate Daily Trending</reportName><classStyles><classStyle name="ls"><CSS value="border-collapse:collapse"/></classStyle><classStyle name="lt"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-left-style:none;background-color:white;color:black;text-align:left;font-weight:bold;border-bottom:1.5pt solid black"/></classStyle><classStyle name="lc"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lm"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lf"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="ih"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="if"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="is"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="oh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="of"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="os"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle></classStyles><queries><query name="Query1">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL4" type="passThrough">
			<sqlText>SELECT 	SUBSTR(dwh_capacity.storage_pool_dimension.name, 1, LOCATE(':', dwh_capacity.storage_pool_dimension.name) - 1) AS 'Storage System',
	dwh_capacity.storage_pool_dimension.name AS 'Aggregate',
	DATE(dwh_capacity.date_dimension.fullDate) AS 'Date',
	ROUND(dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB/1024, 2) AS 'Total Raw Space',
	ROUND(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB/1024, 2) AS 'Total Space',
	ROUND(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB/1024, 2) AS 'Used Space',
	ROUND(dwh_capacity.storage_and_storage_pool_capacity_fact.usedcapacityMB/dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB, 4) AS 'Used Space (%)',
	ROUND((dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB - dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024, 2) AS 'Available Space',
	ROUND(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB/1024, 2) AS 'Committed Space',
	ROUND(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB/dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB, 4) AS 'Commited Space (%)'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
JOIN 	dwh_capacity.storage_pool_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
AND 	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
AND 	dwh_capacity.storage_pool_dimension.name LIKE '%:%'
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.Tk
GROUP BY
	dwh_capacity.storage_pool_dimension.name,
	dwh_capacity.date_dimension.fullDate</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage System"/><mdProjectedItem name="Aggregate"/><mdProjectedItem name="Date"/><mdProjectedItem name="Total Raw Space"/><mdProjectedItem name="Total Space"/><mdProjectedItem name="Used Space"/><mdProjectedItem name="Used Space (%)"/><mdProjectedItem name="Available Space"/><mdProjectedItem name="Committed Space"/><mdProjectedItem name="Commited Space (%)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage System"><expression>[SQL4].[Storage System]</expression></dataItem><dataItem name="Aggregate"><expression>[SQL4].[Aggregate]</expression></dataItem><dataItem name="Date"><expression>[SQL4].[Date]</expression></dataItem><dataItem name="Total Raw Space"><expression>[SQL4].[Total Raw Space]</expression></dataItem><dataItem name="Total Space"><expression>[SQL4].[Total Space]</expression></dataItem><dataItem name="Used Space"><expression>[SQL4].[Used Space]</expression></dataItem><dataItem name="Used Space (%)"><expression>[SQL4].[Used Space (%)]</expression></dataItem><dataItem name="Available Space"><expression>[SQL4].[Available Space]</expression></dataItem><dataItem name="Committed Space"><expression>[SQL4].[Committed Space]</expression></dataItem><dataItem name="Commited Space (%)"><expression>[SQL4].[Commited Space (%)]</expression></dataItem><dataItem name="Change in Used Space"><expression>running-difference([SQL4].[Used Space] for [SQL4].[Aggregate])</expression></dataItem><dataItem name="Change in Used Space (%)"><expression>running-difference([SQL4].[Used Space (%)] for [SQL4].[Aggregate])</expression></dataItem><dataItem name="Change in Committed Space"><expression>running-difference([SQL4].[Committed Space] for [SQL4].[Aggregate])</expression></dataItem><dataItem name="Change in Commited Space (%)"><expression>running-difference([SQL4].[Commited Space (%)] for [SQL4].[Aggregate])</expression></dataItem></selection>
		</query><query name="Latest Date">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL1">
			<sqlText>SELECT DATE(dd.fullDate) latestdate
FROM 
   dwh_capacity.date_dimension dd
WHERE 
   dd.latest=1</sqlText>
		<mdProjectedItems><mdProjectedItem name="latestdate"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="latestdate"><expression>[SQL1].[latestdate]</expression></dataItem></selection>
		</query></queries></report>